package www.test.utils;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;



public class KeyId
{
	
	public static String getKeyId()
	{
		
		String id ="";
		Connection conn = null;
		PreparedStatement st = null;
		ResultSet rs = null ;
		try
		{
			conn = jdbcUtils.getConnection();
			String sql ="SELECT FN_GET_SYS_KEY FROM DUAL";
			st= conn.prepareStatement(sql);
			rs=st.executeQuery();
			if(rs.next())
			{
				id = rs.getString("FN_GET_SYS_KEY");
			}
			return id;
			
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			jdbcUtils.release(conn, st, rs);
		}
		return null;
	}

}
